Pandas Profiling Report

Dataset statistics

Number of variables	17
Number of observations	3491
Missing cells	929
Missing cells (%)	1.6%
Duplicate rows	31
Duplicate rows (%)	0.9%
Total size in memory	416.0 KiB
Average record size in memory	122.0 B

Variable types

Numeric	8
Text	3
Unsupported	1
Categorical	2
DateTime	1
Boolean	2

Alerts

`cooperate` has constant value "True"	Constant
Dataset has 31 (0.9%) duplicate rows	Duplicates
`baths` is highly overall correlated with `beds` and 5 other fields	High correlation
`beds` is highly overall correlated with `baths` and 5 other fields	High correlation
`max_price` is highly overall correlated with `baths` and 5 other fields	High correlation
`net_price` is highly overall correlated with `baths` and 5 other fields	High correlation
`new_price` is highly overall correlated with `baths` and 5 other fields	High correlation
`old_price` is highly overall correlated with `baths` and 5 other fields	High correlation
`sqft` is highly overall correlated with `baths` and 5 other fields	High correlation
`concession_title` has 905 (25.9%) missing values	Missing
`unit_number` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`baths` has 37 (1.1%) zeros	Zeros

Reproduction

Analysis started	2024-09-19 13:11:04.755199
Analysis finished	2024-09-19 13:11:21.611609
Duration	16.86 seconds
Software version	ydata-profiling vv4.10.0
Download configuration	config.json

building_id
Real number (ℝ)

Distinct	130
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1375.0163

Minimum	1
Maximum	6378
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.4 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	56
median	103
Q3	293
95-th percentile	6374
Maximum	6378
Range	6377
Interquartile range (IQR)	237

Descriptive statistics

Standard deviation	2431.6147
Coefficient of variation (CV)	1.768426
Kurtosis	0.18788249
Mean	1375.0163
Median Absolute Deviation (MAD)	79
Skewness	1.4442497
Sum	4800182
Variance	5912749.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
6274	230	6.6%
6374	186	5.3%
6279	154	4.4%
293	124	3.6%
104	121	3.5%
95	115	3.3%
100	99	2.8%
97	92	2.6%
91	74	2.1%
21	64	1.8%
Other values (120)	2232	63.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	58	1.7%
2	24	0.7%
3	36	1.0%
4	29	0.8%
6	34	1.0%
9	4	0.1%
10	54	1.5%
11	1	< 0.1%
13	16	0.5%
15	31	0.9%

Value	Count	Frequency (%)
6378	26	0.7%
6377	10	0.3%
6374	186	5.3%
6360	3	0.1%
6290	7	0.2%
6289	1	< 0.1%
6280	1	< 0.1%
6279	154	4.4%
6274	230	6.6%
6270	18	0.5%

name
Text

Distinct	129
Distinct (%)	3.7%
Missing	0
Missing (%)	0.0%
Memory size	27.4 KiB

Length

Max length	33
Median length	27
Mean length	15.581495
Min length	3

Characters and Unicode

Total characters	54395
Distinct characters	62
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	8 ?
Unique (%)	0.2%

Sample

1st row	1000 South Clark
2nd row	1000 South Clark
3rd row	1000 South Clark
4th row	1000 South Clark
5th row	1000 South Clark

Value	Count	Frequency (%)
the	411	4.5%
apartments	409	4.5%
park	353	3.9%
alta	312	3.5%
grand	256	2.8%
north	244	2.7%
central	230	2.5%
at	224	2.5%
residences	200	2.2%
aspire	186	2.1%
Other values (188)	6214	68.7%

Most occurring characters

Value	Count	Frequency (%)
	5548	10.2%
e	5025	9.2%
r	4382	8.1%
a	4035	7.4%
t	3585	6.6%
n	2911	5.4%
o	2546	4.7%
s	2221	4.1%
i	2149	4.0%
l	1994	3.7%
Other values (52)	19999	36.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	37704	69.3%
Uppercase Letter	9102	16.7%
Space Separator	5548	10.2%
Decimal Number	2009	3.7%
Math Symbol	18	< 0.1%
Other Punctuation	14	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	5025	13.3%
r	4382	11.6%
a	4035	10.7%
t	3585	9.5%
n	2911	7.7%
o	2546	6.8%
s	2221	5.9%
i	2149	5.7%
l	1994	5.3%
h	1470	3.9%
Other values (15)	7386	19.6%

Uppercase Letter

Value	Count	Frequency (%)
A	1311	14.4%
P	889	9.8%
S	884	9.7%
T	859	9.4%
C	773	8.5%
M	605	6.6%
L	550	6.0%
N	460	5.1%
R	402	4.4%
O	386	4.2%
Other values (14)	1983	21.8%

Decimal Number

Value	Count	Frequency (%)
0	521	25.9%
1	382	19.0%
5	342	17.0%
3	329	16.4%
2	180	9.0%
7	69	3.4%
9	65	3.2%
4	50	2.5%
6	49	2.4%
8	22	1.1%

Space Separator

Value	Count	Frequency (%)
	5548	100.0%

Math Symbol

Value	Count	Frequency (%)
+	18	100.0%

Other Punctuation

Value	Count	Frequency (%)
&	14	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	46806	86.0%
Common	7589	14.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	5025	10.7%
r	4382	9.4%
a	4035	8.6%
t	3585	7.7%
n	2911	6.2%
o	2546	5.4%
s	2221	4.7%
i	2149	4.6%
l	1994	4.3%
h	1470	3.1%
Other values (39)	16488	35.2%

Common

Value	Count	Frequency (%)
	5548	73.1%
0	521	6.9%
1	382	5.0%
5	342	4.5%
3	329	4.3%
2	180	2.4%
7	69	0.9%
9	65	0.9%
4	50	0.7%
6	49	0.6%
Other values (3)	54	0.7%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	54395	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	5548	10.2%
e	5025	9.2%
r	4382	8.1%
a	4035	7.4%
t	3585	6.6%
n	2911	5.4%
o	2546	4.7%
s	2221	4.1%
i	2149	4.0%
l	1994	3.7%
Other values (52)	19999	36.8%

unit_number
Unsupported

REJECTED UNSUPPORTED

Missing	0
Missing (%)	0.0%
Memory size	27.4 KiB

beds
Categorical

HIGH CORRELATION

Distinct	5
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	27.4 KiB

1	1744
0	909
2	718
3	118
4	2

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	3491
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1
2nd row	1
3rd row	1
4th row	1
5th row	1

Common Values

Value	Count	Frequency (%)
1	1744	50.0%
0	909	26.0%
2	718	20.6%
3	118	3.4%
4	2	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
1	1744	50.0%
0	909	26.0%
2	718	20.6%
3	118	3.4%
4	2	0.1%

Most occurring characters

Value	Count	Frequency (%)
1	1744	50.0%
0	909	26.0%
2	718	20.6%
3	118	3.4%
4	2	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	3491	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	1744	50.0%
0	909	26.0%
2	718	20.6%
3	118	3.4%
4	2	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	3491	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
1	1744	50.0%
0	909	26.0%
2	718	20.6%
3	118	3.4%
4	2	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3491	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
1	1744	50.0%
0	909	26.0%
2	718	20.6%
3	118	3.4%
4	2	0.1%

baths
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	6
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.2348897

Minimum	0
Maximum	3
Zeros	37
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	27.4 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1
median	1
Q3	1
95-th percentile	2
Maximum	3
Range	3
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	0.48008787
Coefficient of variation (CV)	0.38876984
Kurtosis	1.6333152
Mean	1.2348897
Median Absolute Deviation (MAD)	0
Skewness	1.3548895
Sum	4311
Variance	0.23048436
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	2636	75.5%
2	703	20.1%
3	47	1.3%
1.5	42	1.2%
0	37	1.1%
2.5	26	0.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	37	1.1%
1	2636	75.5%
1.5	42	1.2%
2	703	20.1%
2.5	26	0.7%
3	47	1.3%

Value	Count	Frequency (%)
3	47	1.3%
2.5	26	0.7%
2	703	20.1%
1.5	42	1.2%
1	2636	75.5%
0	37	1.1%

sqft
Real number (ℝ)

HIGH CORRELATION

Distinct	679
Distinct (%)	19.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	800.94758

Minimum	229
Maximum	3249
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.4 KiB

Quantile statistics

Minimum	229
5-th percentile	485
Q1	608
median	731
Q3	896
95-th percentile	1314.5
Maximum	3249
Range	3020
Interquartile range (IQR)	288

Descriptive statistics

Standard deviation	290.34789
Coefficient of variation (CV)	0.36250549
Kurtosis	6.0348062
Mean	800.94758
Median Absolute Deviation (MAD)	138
Skewness	1.8443109
Sum	2796108
Variance	84301.898
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
720	67	1.9%
750	44	1.3%
656	39	1.1%
716	33	0.9%
740	29	0.8%
565	28	0.8%
785	26	0.7%
570	26	0.7%
759	25	0.7%
715	24	0.7%
Other values (669)	3150	90.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
229	1	< 0.1%
247	2	0.1%
287	2	0.1%
288	4	0.1%
310	1	< 0.1%
316	1	< 0.1%
320	2	0.1%
324	1	< 0.1%
336	3	0.1%
350	1	< 0.1%

Value	Count	Frequency (%)
3249	1	< 0.1%
3050	1	< 0.1%
2700	1	< 0.1%
2466	1	< 0.1%
2298	1	< 0.1%
2280	1	< 0.1%
2267	2	0.1%
2256	1	< 0.1%
2239	1	< 0.1%
2179	1	< 0.1%

neighborhood_name
Categorical

Distinct	28
Distinct (%)	0.8%
Missing	24
Missing (%)	0.7%
Memory size	27.4 KiB

South Loop	1194
River North	490
West Loop	306
Streeterville	259
The Loop	204
Other values (23)	1014

Length

Max length	21
Median length	15
Mean length	10.438419
Min length	6

Characters and Unicode

Total characters	36190
Distinct characters	41
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	0.1%

Sample

1st row	South Loop
2nd row	South Loop
3rd row	South Loop
4th row	South Loop
5th row	South Loop

Common Values

Value	Count	Frequency (%)
South Loop	1194	34.2%
River North	490	14.0%
West Loop	306	8.8%
Streeterville	259	7.4%
The Loop	204	5.8%
Old Town	186	5.3%
Gold Coast	185	5.3%
New East Side	121	3.5%
Old town	83	2.4%
Lincoln Park	72	2.1%
Other values (18)	367	10.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
loop	1704	25.0%
south	1195	17.5%
river	591	8.7%
north	516	7.6%
west	343	5.0%
old	269	3.9%
town	269	3.9%
streeterville	259	3.8%
the	204	3.0%
coast	185	2.7%
Other values (26)	1277	18.7%

Most occurring characters

Value	Count	Frequency (%)
o	6090	16.8%
	3345	9.2%
t	3236	8.9%
e	2791	7.7%
r	1934	5.3%
h	1916	5.3%
L	1822	5.0%
p	1715	4.7%
S	1607	4.4%
u	1332	3.7%
Other values (31)	10402	28.7%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	26116	72.2%
Uppercase Letter	6729	18.6%
Space Separator	3345	9.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
o	6090	23.3%
t	3236	12.4%
e	2791	10.7%
r	1934	7.4%
h	1916	7.3%
p	1715	6.6%
u	1332	5.1%
i	1295	5.0%
l	1273	4.9%
v	918	3.5%
Other values (11)	3616	13.8%

Uppercase Letter

Value	Count	Frequency (%)
L	1822	27.1%
S	1607	23.9%
N	664	9.9%
R	610	9.1%
T	390	5.8%
W	347	5.2%
O	269	4.0%
G	215	3.2%
C	186	2.8%
E	127	1.9%
Other values (9)	492	7.3%

Space Separator

Value	Count	Frequency (%)
	3345	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	32845	90.8%
Common	3345	9.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
o	6090	18.5%
t	3236	9.9%
e	2791	8.5%
r	1934	5.9%
h	1916	5.8%
L	1822	5.5%
p	1715	5.2%
S	1607	4.9%
u	1332	4.1%
i	1295	3.9%
Other values (30)	9107	27.7%

Common

Value	Count	Frequency (%)
	3345	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	36190	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
o	6090	16.8%
	3345	9.2%
t	3236	8.9%
e	2791	7.7%
r	1934	5.3%
h	1916	5.3%
L	1822	5.0%
p	1715	4.7%
S	1607	4.4%
u	1332	3.7%
Other values (31)	10402	28.7%

concession_title
Text

MISSING

Distinct	67
Distinct (%)	2.6%
Missing	905
Missing (%)	25.9%
Memory size	27.4 KiB

Length

Max length	203
Median length	157
Mean length	65.682135
Min length	1

Characters and Unicode

Total characters	169854
Distinct characters	70
Distinct categories	11 ?
Distinct scripts	2 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	4 ?
Unique (%)	0.2%

Sample

1st row	1 Month Off Available on all unit types for a limited time!
2nd row	1 Month Off Available on all unit types for a limited time!
3rd row	1 Month Off Available on all unit types for a limited time!
4th row	1 Month Off Available on all unit types for a limited time!
5th row	1 Month Off Available on all unit types for a limited time!

Value	Count	Frequency (%)
free	1735	5.4%
on	1660	5.2%
month	1216	3.8%
months	1199	3.8%
	1043	3.3%
and	1011	3.2%
off	886	2.8%
1	707	2.2%
of	649	2.0%
rent	624	2.0%
Other values (208)	21116	66.3%

Most occurring characters

Value	Count	Frequency (%)
	29436	17.3%
e	15306	9.0%
o	12650	7.4%
n	11190	6.6%
t	10380	6.1%
i	8035	4.7%
r	7916	4.7%
s	7507	4.4%
f	6171	3.6%
a	5406	3.2%
Other values (60)	55857	32.9%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	117804	69.4%
Space Separator	29436	17.3%
Decimal Number	8280	4.9%
Uppercase Letter	7964	4.7%
Other Punctuation	4396	2.6%
Currency Symbol	931	0.5%
Dash Punctuation	837	0.5%
Math Symbol	56	< 0.1%
Other Symbol	54	< 0.1%
Close Punctuation	48	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	15306	13.0%
o	12650	10.7%
n	11190	9.5%
t	10380	8.8%
i	8035	6.8%
r	7916	6.7%
s	7507	6.4%
f	6171	5.2%
a	5406	4.6%
l	5212	4.4%
Other values (14)	28031	23.8%

Uppercase Letter

Value	Count	Frequency (%)
A	1079	13.5%
F	976	12.3%
O	959	12.0%
M	839	10.5%
L	516	6.5%
S	460	5.8%
C	395	5.0%
J	364	4.6%
B	360	4.5%
E	275	3.5%
Other values (11)	1741	21.9%

Decimal Number

Value	Count	Frequency (%)
1	2064	24.9%
2	1405	17.0%
0	1313	15.9%
5	1229	14.8%
4	827	10.0%
8	538	6.5%
6	419	5.1%
3	264	3.2%
7	121	1.5%
9	100	1.2%

Other Punctuation

Value	Count	Frequency (%)
.	2018	45.9%
,	941	21.4%
!	461	10.5%
&	425	9.7%
;	327	7.4%
/	134	3.0%
:	90	2.0%

Currency Symbol

Value	Count	Frequency (%)
$	877	94.2%
€	54	5.8%

Space Separator

Value	Count	Frequency (%)
	29436	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	837	100.0%

Math Symbol

Value	Count	Frequency (%)
+	56	100.0%

Other Symbol

Value	Count	Frequency (%)
™	54	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	48	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	48	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	125768	74.0%
Common	44086	26.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	15306	12.2%
o	12650	10.1%
n	11190	8.9%
t	10380	8.3%
i	8035	6.4%
r	7916	6.3%
s	7507	6.0%
f	6171	4.9%
a	5406	4.3%
l	5212	4.1%
Other values (35)	35995	28.6%

Common

Value	Count	Frequency (%)
	29436	66.8%
1	2064	4.7%
.	2018	4.6%
2	1405	3.2%
0	1313	3.0%
5	1229	2.8%
,	941	2.1%
$	877	2.0%
-	837	1.9%
4	827	1.9%
Other values (15)	3139	7.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	169692	99.9%
Letterlike Symbols	54	< 0.1%
None	54	< 0.1%
Currency Symbols	54	< 0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	29436	17.3%
e	15306	9.0%
o	12650	7.5%
n	11190	6.6%
t	10380	6.1%
i	8035	4.7%
r	7916	4.7%
s	7507	4.4%
f	6171	3.6%
a	5406	3.2%
Other values (57)	55695	32.8%

Letterlike Symbols

Value	Count	Frequency (%)
™	54	100.0%

None

Value	Count	Frequency (%)
â	54	100.0%

Currency Symbols

Value	Count	Frequency (%)
€	54	100.0%

updated_on
Date

Distinct	1699
Distinct (%)	48.7%
Missing	0
Missing (%)	0.0%
Memory size	27.4 KiB

Minimum	2019-11-26 16:40:22.280000
Maximum	2020-08-12 19:21:59.631000

Histogram

Histogram with fixed size bins (bins=50)

old_price
Real number (ℝ)

HIGH CORRELATION

Distinct	1700
Distinct (%)	48.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2416.5781

Minimum	190
Maximum	18500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.4 KiB

Quantile statistics

Minimum	190
5-th percentile	1355.5
Q1	1800.5
median	2175
Q3	2682.5
95-th percentile	4262
Maximum	18500
Range	18310
Interquartile range (IQR)	882

Descriptive statistics

Standard deviation	1047.1939
Coefficient of variation (CV)	0.43333749
Kurtosis	28.719138
Mean	2416.5781
Median Absolute Deviation (MAD)	427
Skewness	3.5978363
Sum	8436274
Variance	1096615
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1740	13	0.4%
2087	12	0.3%
1655	11	0.3%
1695	10	0.3%
1675	10	0.3%
1250	9	0.3%
1660	9	0.3%
1710	9	0.3%
1659	8	0.2%
1885	8	0.2%
Other values (1690)	3392	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
190	1	< 0.1%
899	3	0.1%
951	1	< 0.1%
986	1	< 0.1%
995	3	0.1%
999	2	0.1%
1004	2	0.1%
1009	1	< 0.1%
1019	2	0.1%
1050	2	0.1%

Value	Count	Frequency (%)
18500	1	< 0.1%
13378	1	< 0.1%
13000	1	< 0.1%
11000	1	< 0.1%
9855	1	< 0.1%
8501	1	< 0.1%
8491	1	< 0.1%
8450	1	< 0.1%
8058	1	< 0.1%
8033	1	< 0.1%

new_price
Real number (ℝ)

HIGH CORRELATION

Distinct	1697
Distinct (%)	48.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2386.7754

Minimum	919
Maximum	13750
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.4 KiB

Quantile statistics

Minimum	919
5-th percentile	1349
Q1	1765
median	2150
Q3	2655.5
95-th percentile	4256.5
Maximum	13750
Range	12831
Interquartile range (IQR)	890.5

Descriptive statistics

Standard deviation	1013.806
Coefficient of variation (CV)	0.42475971
Kurtosis	16.575732
Mean	2386.7754
Median Absolute Deviation (MAD)	425
Skewness	2.9609702
Sum	8332233
Variance	1027802.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2195	11	0.3%
1935	11	0.3%
1980	10	0.3%
1660	10	0.3%
1915	9	0.3%
1735	9	0.3%
2175	9	0.3%
2295	9	0.3%
1340	9	0.3%
1765	9	0.3%
Other values (1687)	3395	97.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
919	3	0.1%
949	1	< 0.1%
984	1	< 0.1%
995	1	< 0.1%
1008	1	< 0.1%
1018	2	0.1%
1041	1	< 0.1%
1046	1	< 0.1%
1065	3	0.1%
1084	2	0.1%

Value	Count	Frequency (%)
13750	1	< 0.1%
13468	1	< 0.1%
11500	1	< 0.1%
9500	1	< 0.1%
8558	1	< 0.1%
8548	1	< 0.1%
8480	1	< 0.1%
8316	1	< 0.1%
7999	1	< 0.1%
7914	1	< 0.1%

max_price
Real number (ℝ)

HIGH CORRELATION

Distinct	324
Distinct (%)	9.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2898.4847

Minimum	951
Maximum	18500
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.4 KiB

Quantile statistics

Minimum	951
5-th percentile	1530
Q1	2135
median	2608
Q3	3100
95-th percentile	4977.5
Maximum	18500
Range	17549
Interquartile range (IQR)	965

Descriptive statistics

Standard deviation	1546.1649
Coefficient of variation (CV)	0.53343905
Kurtosis	35.725634
Mean	2898.4847
Median Absolute Deviation (MAD)	483
Skewness	4.8154813
Sum	10118610
Variance	2390625.9
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2362	185	5.3%
2888	142	4.1%
1865	80	2.3%
2325	72	2.1%
2940	69	2.0%
2861	63	1.8%
2459	59	1.7%
1966	59	1.7%
4203	45	1.3%
1530	45	1.3%
Other values (314)	2672	76.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
951	4	0.1%
1019	4	0.1%
1050	1	< 0.1%
1117	10	0.3%
1175	1	< 0.1%
1201	1	< 0.1%
1300	2	0.1%
1310	2	0.1%
1326	5	0.1%
1340	1	< 0.1%

Value	Count	Frequency (%)
18500	10	0.3%
13468	1	< 0.1%
11000	28	0.8%
9855	3	0.1%
8558	10	0.3%
8480	1	< 0.1%
8316	1	< 0.1%
8058	16	0.5%
7791	1	< 0.1%
7640	3	0.1%

net_price
Real number (ℝ)

HIGH CORRELATION

Distinct	1712
Distinct (%)	49.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2287.6671

Minimum	919
Maximum	13468
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.4 KiB

Quantile statistics

Minimum	919
5-th percentile	1310
Q1	1700.5
median	2053
Q3	2544
95-th percentile	4053.5
Maximum	13468
Range	12549
Interquartile range (IQR)	843.5

Descriptive statistics

Standard deviation	966.56567
Coefficient of variation (CV)	0.4225115
Kurtosis	16.840471
Mean	2287.6671
Median Absolute Deviation (MAD)	393
Skewness	2.9680482
Sum	7986246
Variance	934249.19
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1615	10	0.3%
1992	9	0.3%
1685	9	0.3%
1849	9	0.3%
2175	8	0.2%
1735	8	0.2%
1660	8	0.2%
1742	8	0.2%
1755	8	0.2%
1935	8	0.2%
Other values (1702)	3406	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
919	3	0.1%
929	1	< 0.1%
949	1	< 0.1%
984	1	< 0.1%
1008	1	< 0.1%
1018	2	0.1%
1041	1	< 0.1%
1046	1	< 0.1%
1065	3	0.1%
1080	1	< 0.1%

Value	Count	Frequency (%)
13468	1	< 0.1%
12833	1	< 0.1%
10733	1	< 0.1%
8867	1	< 0.1%
8480	1	< 0.1%
8316	1	< 0.1%
7999	1	< 0.1%
7987	1	< 0.1%
7978	1	< 0.1%
7914	1	< 0.1%

price_per_sqft
Real number (ℝ)

Distinct	1586
Distinct (%)	45.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.8781558

Minimum	1.429
Maximum	5.861
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	27.4 KiB

Quantile statistics

Minimum	1.429
5-th percentile	2.102
Q1	2.4835
median	2.836
Q3	3.199
95-th percentile	3.8215
Maximum	5.861
Range	4.432
Interquartile range (IQR)	0.7155

Descriptive statistics

Standard deviation	0.54722763
Coefficient of variation (CV)	0.19013134
Kurtosis	1.4007697
Mean	2.8781558
Median Absolute Deviation (MAD)	0.357
Skewness	0.75694571
Sum	10047.642
Variance	0.29945808
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2.934	9	0.3%
2.694	9	0.3%
3.27	9	0.3%
2.613	9	0.3%
2.728	8	0.2%
2.057	8	0.2%
2.393	8	0.2%
2.293	8	0.2%
2.403	8	0.2%
2.987	8	0.2%
Other values (1576)	3407	97.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1.429	1	< 0.1%
1.501	1	< 0.1%
1.509	1	< 0.1%
1.518	1	< 0.1%
1.522	2	0.1%
1.533	1	< 0.1%
1.538	1	< 0.1%
1.562	1	< 0.1%
1.576	2	0.1%
1.588	1	< 0.1%

Value	Count	Frequency (%)
5.861	1	< 0.1%
5.629	1	< 0.1%
5.217	1	< 0.1%
5.198	1	< 0.1%
5.194	1	< 0.1%
5.189	2	0.1%
5.185	1	< 0.1%
5.147	1	< 0.1%
5.062	1	< 0.1%
5.01	2	0.1%

percentage_change
Text

Distinct	2107
Distinct (%)	60.4%
Missing	0
Missing (%)	0.0%
Memory size	27.4 KiB

Length

Max length	7
Median length	7
Mean length	6.7250072
Min length	5

Characters and Unicode

Total characters	23477
Distinct characters	13
Distinct categories	3 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1300 ?
Unique (%)	37.2%

Sample

1st row	-26.01%
2nd row	-21.08%
3rd row	-29.61%
4th row	-30.23%
5th row	-33.10%

Value	Count	Frequency (%)
0.00	86	2.5%
6.67	20	0.6%
10.00	14	0.4%
6.65	9	0.3%
3.47	7	0.2%
6.68	7	0.2%
11.90	7	0.2%
16.09	7	0.2%
16.67	7	0.2%
7.78	6	0.2%
Other values (2097)	3321	95.1%

Most occurring characters

Value	Count	Frequency (%)
.	3491	14.9%
%	3491	14.9%
-	3405	14.5%
1	2122	9.0%
2	1965	8.4%
0	1428	6.1%
3	1423	6.1%
4	1090	4.6%
7	1061	4.5%
5	1053	4.5%
Other values (3)	2948	12.6%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	13090	55.8%
Other Punctuation	6982	29.7%
Dash Punctuation	3405	14.5%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
1	2122	16.2%
2	1965	15.0%
0	1428	10.9%
3	1423	10.9%
4	1090	8.3%
7	1061	8.1%
5	1053	8.0%
6	1041	8.0%
9	964	7.4%
8	943	7.2%

Other Punctuation

Value	Count	Frequency (%)
.	3491	50.0%
%	3491	50.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3405	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	23477	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
.	3491	14.9%
%	3491	14.9%
-	3405	14.5%
1	2122	9.0%
2	1965	8.4%
0	1428	6.1%
3	1423	6.1%
4	1090	4.6%
7	1061	4.5%
5	1053	4.5%
Other values (3)	2948	12.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	23477	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
.	3491	14.9%
%	3491	14.9%
-	3405	14.5%
1	2122	9.0%
2	1965	8.4%
0	1428	6.1%
3	1423	6.1%
4	1090	4.6%
7	1061	4.5%
5	1053	4.5%
Other values (3)	2948	12.6%

cooperate
Boolean

CONSTANT

Distinct	1
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 KiB

True	3491

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
True	3491	100.0%

concession_applied
Boolean

Distinct	2
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	3.5 KiB

False	1851
True	1640

Common Values (Table)
Common Values (Plot)

Value	Count	Frequency (%)
False	1851	53.0%
True	1640	47.0%

Auto

Heatmap
Table

	baths	beds	building_id	concession_applied	max_price	neighborhood_name	net_price	new_price	old_price	price_per_sqft	sqft
baths	1.000	0.566	-0.037	0.053	0.597	0.189	0.567	0.565	0.564	-0.110	0.656
beds	0.566	1.000	0.115	0.119	0.585	0.374	0.534	0.555	0.566	0.296	0.641
building_id	-0.037	0.115	1.000	0.055	-0.008	0.455	-0.060	-0.050	-0.018	0.106	-0.137
concession_applied	0.053	0.119	0.055	1.000	0.198	0.422	0.051	0.118	0.098	0.170	0.054
max_price	0.597	0.585	-0.008	0.198	1.000	0.212	0.876	0.889	0.887	0.289	0.713
neighborhood_name	0.189	0.374	0.455	0.422	0.212	1.000	0.133	0.132	0.137	0.238	0.286
net_price	0.567	0.534	-0.060	0.051	0.876	0.133	1.000	0.983	0.974	0.338	0.797
new_price	0.565	0.555	-0.050	0.118	0.889	0.132	0.983	1.000	0.989	0.318	0.795
old_price	0.564	0.566	-0.018	0.098	0.887	0.137	0.974	0.989	1.000	0.309	0.792
price_per_sqft	-0.110	0.296	0.106	0.170	0.289	0.238	0.338	0.318	0.309	1.000	-0.223
sqft	0.656	0.641	-0.137	0.054	0.713	0.286	0.797	0.795	0.792	-0.223	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	building_id	name	unit_number	beds	baths	sqft	neighborhood_name	concession_title	updated_on	old_price	new_price	max_price	net_price	price_per_sqft	percentage_change	cooperate	concession_applied
0	1	1000 South Clark	2507	1	1.0	730	South Loop	1 Month Off Available on all unit types for a limited time!	2020-07-23 16:47:51.661	2268	2313	2918	2159	2.957	-26.01%	True	True
1	1	1000 South Clark	1615	1	1.0	765	South Loop	1 Month Off Available on all unit types for a limited time!	2020-08-01 19:46:25.883	2419	2467	2918	2303	3.010	-21.08%	True	True
2	1	1000 South Clark	1806	1	1.0	645	South Loop	1 Month Off Available on all unit types for a limited time!	2020-08-05 11:30:16.886	2158	2201	2918	2054	3.185	-29.61%	True	True
3	1	1000 South Clark	2717	1	1.0	710	South Loop	1 Month Off Available on all unit types for a limited time!	2020-08-01 11:33:52.353	2178	2181	2918	2036	2.867	-30.23%	True	True
4	1	1000 South Clark	1817	1	1.0	710	South Loop	1 Month Off Available on all unit types for a limited time!	2020-08-01 11:33:52.353	2088	2091	2918	1952	2.749	-33.10%	True	True
5	1	1000 South Clark	1417	1	1.0	710	South Loop	1 Month Off Available on all unit types for a limited time!	2020-08-01 11:33:52.353	2048	2051	2918	1914	2.696	-34.41%	True	True
6	1	1000 South Clark	1002	1	1.0	660	South Loop	1 Month Off Available on all unit types for a limited time!	2020-08-11 05:49:52.670	2003	2006	2918	1872	2.837	-35.85%	True	True
7	1	1000 South Clark	2609	1	1.0	722	South Loop	1 Month Off Available on all unit types for a limited time!	2020-08-01 11:33:52.353	2338	2342	2918	2186	3.028	-25.09%	True	True
8	1	1000 South Clark	715	1	1.0	765	South Loop	1 Month Off Available on all unit types for a limited time!	2020-08-12 11:38:20.535	2328	2283	2918	2131	2.785	-26.97%	True	True
9	1	1000 South Clark	609	1	1.0	722	South Loop	1 Month Off Available on all unit types for a limited time!	2020-08-01 11:33:52.353	2328	2332	2918	2177	3.015	-25.39%	True	True

	building_id	name	unit_number	beds	baths	sqft	neighborhood_name	concession_title	updated_on	old_price	new_price	max_price	net_price	price_per_sqft	percentage_change	cooperate	concession_applied
3481	6378	The Bernardin	2401	2	2.0	1399	River North	Currently offering 1.5 months free if move in is by August 25th. 1 month free for on everything else.	2020-08-12 10:17:12.765	3830	3814	3830	3433	2.454	-10.37%	True	True
3482	6378	The Bernardin	2309	2	2.0	1255	River North	Currently offering 1.5 months free if move in is by August 25th. 1 month free for on everything else.	2020-08-12 10:17:21.474	3563	3548	3830	3193	2.544	-16.63%	True	True
3483	6378	The Bernardin	701	2	2.0	1405	River North	Currently offering 1.5 months free if move in is by August 25th. 1 month free for on everything else.	2020-08-12 10:17:18.734	3278	3265	3830	2939	2.091	-23.26%	True	True
3484	6378	The Bernardin	2109	2	2.0	1261	River North	Currently offering 1.5 months free if move in is by August 25th. 1 month free for on everything else.	2020-08-12 10:17:12.765	2983	2971	3830	2674	2.120	-30.18%	True	True
3485	6378	The Bernardin	2301	2	2.0	1399	River North	Currently offering 1.5 months free if move in is by August 25th. 1 month free for on everything else.	2020-08-12 10:17:19.753	3522	3508	3830	3157	2.257	-17.57%	True	True
3486	6378	The Bernardin	801	2	2.0	1405	River North	Currently offering 1.5 months free if move in is by August 25th. 1 month free for on everything else.	2020-08-12 10:17:13.839	3289	3275	3830	2948	2.098	-23.03%	True	True
3487	6378	The Bernardin	2201	2	2.0	1399	River North	Currently offering 1.5 months free if move in is by August 25th. 1 month free for on everything else.	2020-08-12 10:17:09.411	3622	3606	3830	3245	2.320	-15.27%	True	True
3488	6378	The Bernardin	2204	2	2.0	1244	River North	Currently offering 1.5 months free if move in is by August 25th. 1 month free for on everything else.	2020-08-12 10:17:13.488	3375	3361	3830	3025	2.432	-21.02%	True	True
3489	6378	The Bernardin	2306	2	2.0	1174	River North	Currently offering 1.5 months free if move in is by August 25th. 1 month free for on everything else.	2020-08-12 10:17:21.474	3409	3396	3830	3056	2.603	-20.21%	True	True
3490	6378	The Bernardin	1001	2	2.0	1405	River North	Currently offering 1.5 months free if move in is by August 25th. 1 month free for on everything else.	2020-08-12 10:17:18.734	3309	3296	3830	2966	2.111	-22.56%	True	True

Most frequently occurring

	building_id	name	beds	baths	sqft	neighborhood_name	concession_title	updated_on	old_price	new_price	max_price	net_price	price_per_sqft	percentage_change	cooperate	concession_applied	# duplicates
17	100	Park Michigan	2	2.0	968	South Loop	NaN	2020-08-02 11:24:19.941	2297	2298	2774	1992	2.057	-28.19%	True	True	5
19	106	Ravenswood Terrace	1	1.0	632	Ravenswood	NaN	2020-08-07 15:01:55.463	1740	1618	1865	1618	2.560	-13.24%	True	False	5
0	10	215 West Apartments	0	0.0	517	The Loop	.	2020-08-06 07:42:36.633	1610	1620	1800	1620	3.133	-10.00%	True	False	3
1	10	215 West Apartments	0	0.0	656	The Loop	.	2020-08-06 07:42:36.633	1695	1660	1800	1660	2.530	-7.78%	True	False	3
3	10	215 West Apartments	0	0.0	656	The Loop	.	2020-08-06 07:42:36.633	1725	1690	1800	1690	2.576	-6.11%	True	False	3
4	10	215 West Apartments	0	0.0	656	The Loop	.	2020-08-06 07:42:36.633	1735	1700	1800	1700	2.591	-5.56%	True	False	3
16	100	Park Michigan	2	2.0	968	South Loop	NaN	2020-08-02 11:24:19.941	2247	2248	2774	1948	2.013	-29.78%	True	True	3
20	106	Ravenswood Terrace	1	1.0	632	Ravenswood	NaN	2020-08-07 15:01:55.463	1765	1643	1865	1643	2.600	-11.90%	True	False	3
2	10	215 West Apartments	0	0.0	656	The Loop	.	2020-08-06 07:42:36.633	1715	1680	1800	1680	2.561	-6.67%	True	False	2
5	10	215 West Apartments	1	1.0	750	The Loop	.	2020-08-06 07:42:36.633	2155	2115	2255	2115	2.820	-6.21%	True	False	2

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Space Separator

Math Symbol

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Currency Symbol

Space Separator

Dash Punctuation

Math Symbol

Other Symbol

Close Punctuation

Open Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Letterlike Symbols

None

Currency Symbols

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Dash Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks